A Guide to Building a CryptoCurrency Dashboard in Tableau

on

Tableau is the most powerful Visualization tool that every Data Science Student needs to know. In recent years we have mostly heard about the word Cryptocurrency, Crypto is nothing but it is a Digital currency. As an AI student I welcome you all to the next series of  “Life of AI Students” blog. In this blog it talks about the Interactive Cryptocurrency Dashboard using tableau.


Tableau

Tableau is the most powerful data Visualization and BI(Business Intelligence) tool. It is used to create an interactive Dashboard and Storyboard by using charts, graphs, maps etc… Most Data Scientists and Data Analysis use Tableau to complete a quick Visualization. Tableau offers  Six platforms to create our Visualization, they are…


Tableau also provides a Student license for the Students who are interested in Learning Tableau and also offers a License to Study the free course about Tableau. In recent years Data Science has become a very important job in our society, so learning Tableau may help you to get a good job or an internship. 


Cryptocurrency 

Cryptocurrency is nothing but a Digital or Virtual Currency. It has more value than real money. It uses cryptography Security which hides the information. It doesn't need any bank or government to supervise it. The well known Cryptocurrency is Bitcoin. Which was created in 2009 by Satoshi Nakamoto. After this many cryptocurrency have been developed like Ethereum, litecoin, dogecoin, etc… Nearly 23,000 Cryptocurrency are there in the world now. In that nearly 9,000 are active. The main use of cryptocurrency is, it can't be hacked and no illegal activities are occurring. Overall crypto is a recently emerged field and it is unpredictable. 


So that the Crypto currency Dashboard with Visualization tool is really a good looking Project for a High School student.


DASHBOARD:

This Dashboard Contains 7 charts



Step :1 

Import the Data containing coin name, Symbol, Open price, close price, Total number of Volume, high value, Low value, Date and the market cap. These parameters are very important to create a Crypto Dashboard. After loading the Dataset you will be able to see the Measures and Dimensions which means the String and Integers are separated into Green and Blue color at the left side of the Tableau Desktop. Analyze the Dataset very Clearly.


Dataset : Click Here


Step 2:

Create a Charts to create a Dashboard


Sheet 1:

At default the tableau opens in the sheet one. Using the market cap and Date, create a Gantt bar chart. At the Top Right side of the Tableau Desktop you can see the “Show me” option, from there you can select the Gantt bar chart. If you can’t, open the automatic option you can see in the Marks box, from there you can select the Gantt bar Chart. Color and Size the Gantt bar by using the Market Cap column. Now, right click the mouse you can see the “Trend Lines” choose the option, Now your Chart shows the trend based gantt chart of Market cap by the date wise.


Sheet 2:

Now click the “+” Symbol near the sheet 1 then Sheet 2 will open. At the Sheet 2 using the Volume and Date, create a Line Chart. Use the same step which I said in Sheet 1. In here color and size the line chart by Volume. Lighten the trend line if you need. Now your chart shows the trend based Line Chart of Volume by the Date wise.


Sheet 3:

Now open the new Sheet, Using Open, Close price and Date create Bar Chart. Use the same step which I said in Sheet 1. In here color and size the Bar chart by Open and Close price. Now less the size of a Close price. At the Close price Column right click it you will be able to see the “Dual axis” choose the option. Now your chart shows the trend based Bar Chart of Open and Close Price by the Date wise.


Sheet 4:

Now open the new Sheet. Here right click an open “Create Calculation Field”, there use a simple logical coding to create Average price of the crypto “[High (Union)]-[Low (Union)]”. Using the Average and Date create Area Chart. Use the same step which I said in Sheet 1.Now right click the chart you will be able to see the “Forecast” option, Tick the option. Now your chart  will Forecast the Future Average price. In here color the Area chart by Forecast. Now your chart shows the Forecast based Area Chart of Average Price by the Date wise.


Sheet 5:

Open the new Sheet and again repeat the Sheet 4 and Visualize the chart in the Bar Chart. Then your chart shows the Forecast based Bar Chart of Average Price by the Date wise.


Sheet 6:

Open the new Sheet and again repeat the Sheet 1 and Visualize the chart in the Pie Chart. Then your chart shows the Volume of the crypto by Date wise.


Sheet 7:

Open the new Sheet and create a table using name and Symbol. Before this download the needed cryptocurrency image. Shape the name and add the downloaded images in the shapes. 


Step 3:

Near to the “sheet +” you will be able to see the other “+” symbol. Click the symbol and open the Dashboard. In the Dashboard you will be able to see the “Tiled and Floating” at the left Bottom of the Dashboard. Move to Floating and import the already created Charts and arrange it to your understanding. Add images to make your dashboard some more good and attractive.


In this, I have fully explained how to make a Simple Crypto Dashboard in Tableau. You can also create a Storyboard by combining multiple dashboards If anybody needs to know more about Cryptocurrency or tableau feel free to comment or else contact me personally. 

Comments

Post a Comment